In this video, we will learn about spotlight spot lanes and mini charts that reside in a cell in exile.
As you can see here, I have fusebox lines drawn.
You can see in this single cell or face, I have this small line chart which is representing the trend
of these values.
So spotlights are usually used to short trend or pain or deviation in the dataset.
However, since spark lines are really tiny, they have limited functionality.
Despite that, small claims are great.
As you can create is easily too short train and make your reports and dashboard look more reader friendly.
There are three types of spotland.
I show you where to find these Parkland's go to insert.
And in this section, you can see there are three types of spotlights line column, and we lost two
Lane will block a lane Chuck and a Singleton column will be a column chart.
The loss will be a plus and minus PayPal.
Jared.
So let's learn how to create a sparkling.
And delete this.
Go to insert line.
So this will be a line type of spogli.
The data range is from C five cell to inflate.
And the cell in which I want it is or finally, if you want to change it, you can change it here.
Click on OK, and here's your spot line.
So as I told you, it's a smaller version of the line.
OK, let's draw a line.
I'd wants to compare whether this spot line is same as Delaine Jr.
So this is a lame jack.
You can see that the trend that we will see in the line chart is also represented by the small sparkling.
So whenever you are shedding a large amount of detail with some other people in your workplace and in
your worksheet, you can not draw big jot, small spots, link and 70 purpose of highlighting that there
is something in the data that you are offering them.
One thing you should not, it is that sense of sparkling is a deciding within a cell.
So if you change size of, say, the size off spot, lane will also change.
So if I increase the height and weight, the height and weight of spot lane will also change that.
Also, if I mudge the cells around it, this park lane will be drawn in all those most cells.
So this will D-line Ibos sparkling second one is the column type.
It is similar to the line lane.
So let us create a column.
Typos partly.
I'll clear this cleared us Park Lane.
You have to go to design option, and within that there is a clear return.
So clear on.
So right now, only one cell is selected.
Or six.
And go to column tigers, partly.
Collecting data.
Location.
OK.
So you can see here's the column by Boss Park Lane, where Haydock Debark is representing the value
of each data point.
If you want this to store expanded to multiple sales, you can my store sells on, you can decide the
sale to have a bigger spogli.
This last tape of sparkling is a win loss or positive, negative type of sparkling.
So whenever devalues positive, it will be shown as a bluebox above an imaginary axis.
And whenever it is negative, it will be shown as a red box below that imaginary axis.
So to create this latest glitter trust.
They lost.
Orange.
OK, so you can see here is a very large type of spottily.
The only difference between type of sparkling and a Windows type of sparkling is the height of column
in a column.
Spogli is giving us the relative value of that particular data point, whereas in this last type of
spottily, the height of column is irrelevant.
If it is above the axis, it is positive.
If it is below, the axis does negative.
So it is plus minus or min lost type of graph.
So this is how we create spark lines or mini charts.
You can also format these spot lines.
You can change its color.
You can change its marker color.
So all those options are also available.
We are not going to discuss it in this lecture.